Is there any dxl script for checking who’s been logged currently into DOORS

llandale - Thu Apr 23 14:45:33 EDT 2009
There is a login history file in the database on the server here:

<database root folder>\v6data\logs\login_history.txt

You cannot query it from the DOORS client directly, but you can run a DXL on the client on the server, that opens that particular windows file. Parsing is difficult. It tells you who logged in when. It doesn't record log outs so you cannot deduce such things as concurrent users.

The Doors Database Server Admin tool, sibling to doors.exe, can tell you who is currently logged in. You can copy that file from a computer that installed the DOORS server. There is a windows and also a DOS based version of this tool. It will let you force log someone out.

>Louie

pete.kowalski - Thu Apr 23 15:14:02 EDT 2009
You could use this script to parse the "login_history.txt" file that Louie has mentioned.

http://galactic-solutions.com/downloads/Parse_Login_History_10.zip

Telelogic-tau-vinod - Fri Apr 24 04:50:50 EDT 2009
Thanks Guys...
This is really helpful...
but, As louie mentioned it give us only information about users who has logged in , but not log outs ...

Thanks
Vinod.

Telelogic-tau-vinod - Fri Apr 24 04:50:50 EDT 2009
Thanks Guys...
This is really helpful...
but, As louie mentioned it give us only information about users who has logged in , but not log outs ...

Thanks
Vinod.

SystemAdmin - Sun Apr 26 19:23:13 EDT 2009

Hi Vinod,

There were several threads on the old Telelogic forums covering how to monitor log in, log out using the license server, the URLs below will take you to these.

https://forum.telelogic.com/customer/doors/messageview.cfm?catid=30&threadid=1549

https://forum.telelogic.com/customer/doors/messageview.cfm?catid=17&threadid=1361

https://forum.telelogic.com/customer/doors//messageview.cfm?catid=30&threadid=5263

https://forum.telelogic.com/customer/doors/messageview.cfm?catid=30&threadid=4071

https://forum.telelogic.com/customer/doors/messageview.cfm?catid=17&threadid=647

Paul Miller
Specification Practices Specialist
EuroCyber
Melbourne, Australia

Telelogic-tau-vinod - Mon Apr 27 08:51:05 EDT 2009
Hi ,
There is admin command (./dbadmin -data port@computer -userlist) which gives the list of user currently logged into doors .Can you please help me ,to run this command with help of batch script ?

Thanks
Vinod.

HiLbiLy - Thu Jul 15 14:06:59 EDT 2010
How do you use this admin command? Is it dxl?

llandale - Thu Jul 15 18:47:19 EDT 2010

Here's my old batch file "v92-userList.bat"

c:
cd \Program Files\IBM\Rational\DOORS\9.2\bin
dbadmin -data 36677@MyDoorsServer -userlist -outfile c:\Doors-Stuff\v92-UserList.txt
start c:\Doors-Stuff\v92-UserList.txt
 
rem dbadmin -help
rem pause

Put that code in that file on your desktop, and double click on it. It does the chore and displays the results, which look like this:

-I- DBADMIN: 1276221136*landalo@NameOfMyLocalPC

There is also the 'dbsadmin.exe' program which does the same thing but is runs on Windows and has a nice dialog box you can see. (The name has an 's' in it, I guess for Window's'.)

• Louie

HiLbiLy - Fri Jul 16 12:35:07 EDT 2010
I tried creating this batch file, but it didn't work. I tried it on both v9.1 (with obvious changes) and v9.2 DOORS. It seems that I don't have a dbadmin feature in the DOORSHOME\bin folder. How do I get this 'dbadmin' feature? I am running XP if that makes a difference, also where can I get the 'dbsadmin.exe' program?
Thanks.

llandale - Fri Jul 16 14:31:31 EDT 2010
Perhaps they are installed when you install the DOORS server. Sorry, hadn't thought of that.

llandale - Thu Jul 15 18:47:19 EDT 2010

Here's my old batch file "v92-userList.bat"

c:
cd \Program Files\IBM\Rational\DOORS\9.2\bin
dbadmin -data 36677@MyDoorsServer -userlist -outfile c:\Doors-Stuff\v92-UserList.txt
start c:\Doors-Stuff\v92-UserList.txt
 
rem dbadmin -help
rem pause

Put that code in that file on your desktop, and double click on it. It does the chore and displays the results, which look like this:

-I- DBADMIN: 1276221136*landalo@NameOfMyLocalPC

There is also the 'dbsadmin.exe' program which does the same thing but is runs on Windows and has a nice dialog box you can see. (The name has an 's' in it, I guess for Window's'.)

• Louie

PDU - Thu Jul 22 11:21:28 EDT 2010
Hi,

you can try the script in attached file. In french, sorry.
You need logging with admin rigths.

Regards

Pierre